Setting Up an ODBC Data Source Connection
- To setup the connection of the data source, you need to install the corresponding driver.
- Then, setup the DSN (Data Source Name) using the ODBC Administrator.
Note: You can consult with the driver provider about how to setup the DSN.

Connecting to ODBC data source in Navicat
- Click the Import from button in Paths and Encoding of the Import Wizard. Choose the data source from the Connection drop-down list and provide valid Username and Password.
Or, type the connection string directly in the Import from text box. - All available tables will be included in the list if connection success.
Just simply choose the tables you wish to import or specify a query using
Add Query button.
